JSP/Servlet Programmers and Coders

java.lang.reflect.InvocationTargetException on Tomcat 6.x/Axis1.4

noreply@blogger.com (Ravinderjeet S. Nagpal) — Fri, 18 Sep 2009 13:29:00 +0000

I devloped the webservice using Apache Axis 1.4 an deployed it on Tomcat 6.x and it was giving some target invocation exception, below mentioned is a part of exception stacktrace while consuming it

java.lang.reflect.InvocationTargetException
   at org.apache.axis.message.SOAPFaultBuilder.createFault(
SOAPFaultBuilder.java:222)
   at org.apache.axis.message.SOAPFaultBuilder.endElement(
SOAPFaultBuilder.java:129)
   at org.apache.axis.encoding.DeserializationContext.endElement(
DeserializationContext.java:1087)
   at
com.sun.org.apache.xerces.internal.parsers.AbstractSAXParser.endElement(Unknown
Source)
   at
com.sun.org.apache.xerces.internal.impl.XMLNSDocumentScannerImpl.scanEndElement(Unknown
Source)

-----------------------------Solution-------------------------------------

Then I thought to search for its solution ut its was vey hectic multiple solutions but no outcome i become drizy but at last i got solution.

The things were simple, i included multiple jar files needed for axis enviornment. I included them in my classpath and also put them in my Tomcat lib folder.

So i remove the axis jars from tomcat/lib but it gives me more exception.

Then, I removed them from classpath and put them in Apache Tomcat /lib folder.

And, Finally, My problem was solved. Actually, Tomcat needs Axis runtime enviornment to deploy webservice.

Thanks to the links I refer
link are here.

Hope this post able to solve your problem, if any.

Bookmark this page

noreply@blogger.com (Ravinderjeet S. Nagpal) — Thu, 05 Feb 2009 11:34:00 +0000

Download xml Schema validation

Download SCBCD Certification Notes (Tips & Tricks)

noreply@blogger.com (Ravinderjeet S. Nagpal) — Thu, 05 Feb 2009 11:30:00 +0000

http://www.ziddu.com/download/3314639/SCBCDBETAEXAMTRICKSANDQUICKREVIEWS.doc.html

Download Struts and Ajax application

noreply@blogger.com (Ravinderjeet S. Nagpal) — Thu, 05 Feb 2009 11:29:00 +0000

http://www.ziddu.com/download/3325081/ajaxandstrutsapplication.zip.html

Download Tree Menu with Ajax

noreply@blogger.com (Ravinderjeet S. Nagpal) — Thu, 05 Feb 2009 11:28:00 +0000

http://www.ziddu.com/download/3325082/simple_tree_menu_with_ajax.zip.html

Download Struts tiles example

noreply@blogger.com (Ravinderjeet S. Nagpal) — Thu, 05 Feb 2009 11:26:00 +0000

http://www.ziddu.com/download/3204984/StrutsTiles.zip.html

noreply@blogger.com (Ravinderjeet S. Nagpal) — Thu, 05 Feb 2009 11:24:00 +0000

DOWNLOAD STRUTS FILE DOWNLOAD EXAMPLE

Download Struts Hibernate and Spring Code example

noreply@blogger.com (Ravinderjeet S. Nagpal) — Thu, 05 Feb 2009 11:23:00 +0000

http://www.ziddu.com/download/3325083/Struts_hibernate_Spring_code_Example.zip.html

noreply@blogger.com (Ravinderjeet S. Nagpal) — Thu, 05 Feb 2009 11:22:00 +0000

Click here

Download Code for Swing Components

noreply@blogger.com (Ravinderjeet S. Nagpal) — Sun, 18 Jan 2009 13:49:00 +0000

http://www.ziddu.com/download/3224828/swingdemos.rar.html

Download Pagination code in JSP/Servlet

noreply@blogger.com (Ravinderjeet S. Nagpal) — Sun, 18 Jan 2009 13:46:00 +0000

http://www.ziddu.com/download/3224792/Pagination.rar.html

Download Struts-AJAX CRUD, Download CRUD in Struts/Ajax

noreply@blogger.com (Ravinderjeet S. Nagpal) — Sun, 18 Jan 2009 13:40:00 +0000

http://www.ziddu.com/download/3224732/struts-ajax-crud.zip.html

Download JSP/Servlet Project for maintainig Events/ Download Event management Project in JSP/SERVLET

noreply@blogger.com (Ravinderjeet S. Nagpal) — Sun, 18 Jan 2009 13:34:00 +0000

http://www.ziddu.com/download/3224682/events_jsp.zip.html

Download JSP/Servlet Project for Mainataining Employee Directory

noreply@blogger.com (Ravinderjeet S. Nagpal) — Sun, 18 Jan 2009 13:26:00 +0000

http://www.ziddu.com/download/3224571/empldir_jsp.zip.html

Download Sample JSP/Servlet project for Classifieds

noreply@blogger.com (Ravinderjeet S. Nagpal) — Sun, 18 Jan 2009 13:24:00 +0000

http://www.ziddu.com/download/3224553/classifieds_jsp.zip.html

Download Sample Bug Tracking System in JSP/Servlet

noreply@blogger.com (Ravinderjeet S. Nagpal) — Sun, 18 Jan 2009 13:22:00 +0000

http://www.ziddu.com/download/3224533/bugtrack_jsp.zip.html

Download BookStore Project in JSP/Servlet with its Database, Download JSP/Servlet Project for BookStore

noreply@blogger.com (Ravinderjeet S. Nagpal) — Sun, 18 Jan 2009 13:20:00 +0000

http://www.ziddu.com/download/3224502/bookstore_jsp.zip.htmlhttp://www.ziddu.com/download/3224502/bookstore_jsp.zip.html

Download 3000 JavaScript Codes Free, Free download javascript codes, 3000 javascript downloads for free.

noreply@blogger.com (Ravinderjeet S. Nagpal) — Fri, 16 Jan 2009 13:47:00 +0000

http://www.ziddu.com/download/3204709/javascriptcodes.rar.html

Download Code for Using Ajax with Struts1.2.9, Ajax and struts, Ajax with Struts

noreply@blogger.com (Ravinderjeet S. Nagpal) — Fri, 16 Jan 2009 11:14:00 +0000

Link to Download ----- http://www.ziddu.com/download/3203595/AjaxusingXMLHttpRequestandStruts.rar.html

Struts 2: Validation

noreply@blogger.com (Ravinderjeet S. Nagpal) — Wed, 14 Jan 2009 07:15:00 +0000

Struts 2: Validation

Traditional CGI and Servlet

noreply@blogger.com (Ravinderjeet S. Nagpal) — Sat, 10 Jan 2009 08:38:00 +0000

Add more friends to your messenger and enjoy! Invite them now.

Java class/code used in extracting the thumbnail from the image.

noreply@blogger.com (Ravinderjeet S. Nagpal) — Sat, 10 Jan 2009 06:43:00 +0000

Java class/code used in extracting the thumbnail from the image.

public class ImageClass {

public static void main(String[] args) throws Exception {

// load image from INFILE
Image image = Toolkit.getDefaultToolkit().getImage(args[0]);

MediaTracker mediaTracker = new MediaTracker(new Container());

mediaTracker.addImage(image, 0);

mediaTracker.waitForID(0);

// determine thumbnail size from WIDTH and HEIGHT

int thumbWidth = 120;
int thumbHeight =80;

System.out.println(" thumb Width = "+ thumbWidth + " thumb Height = "+thumbHeight);

int imageWidth = image.getWidth(null);

int imageHeight = image.getHeight(null);

String outputFile = args[1];

String quality = 75;

System.out.println("imageWidth " +imageHeight);

System.out.println("imageHeight " +imageWidth);

byte[] bytes = imageSizer(imageWidth,imageHeight,thumbWidth,thumbHeight,image,outputFile,quality);

Image image1= Toolkit.getDefaultToolkit().createImage(bytes);

BufferedImage bi = convert(image1);

File file1 = new File("c:\\byteImage.jpg");

BufferedOutputStream out;
try {

out = new BufferedOutputStream(new

FileOutputStream(file1));

out.write(bytes);

out.flush();

out.close();

}
catch(Exception e)
{
e.printStackTrace();
}

System.out.println("Done.");

System.exit(0);

}

private static byte[] imageSizer(int imageWidth,int imageHeight,int thumbWidth,int thumbHeight ,Image image,String outputFile,String qualityOfImage)
{

byte[] imageAsBytes = null;

for(int i = 0 ; i < 3 ; i++)
   {
     double thumbRatio = (double)thumbWidth / (double)thumbHeight;

     System.out.println(" Image Width = "+ imageWidth + " Height = "+imageHeight);

      if (i == 0)
      {
         double imageRatio = (double)imageWidth / (double)imageHeight;

    System.out.println(" Image Ratio"+imageRatio);

    if (thumbRatio < imageRatio)
    {

        thumbHeight = (int)(thumbWidth / imageRatio);

    }
    else
       {
       thumbWidth = (int)(thumbHeight * imageRatio);
       }
    }
    else if(i==2)
    {
         thumbWidth = imageWidth ;

    thumbHeight = imageHeight ;

   }
   else
   {
      thumbWidth = thumbWidth * 2 ;
       thumbHeight = thumbHeight * 2 ;
    }

System.out.println(" After Checking Ratio ::: thumb Width = "+ thumbWidth + " thumb Height = "+thumbHeight);

// draw original image to thumbnail image object and
// scale it to the new size on-the-fly

BufferedImage thumbImage = new BufferedImage(thumbWidth,
thumbHeight, BufferedImage.TYPE_INT_RGB);

Graphics2D graphics2D = thumbImage.createGraphics();

graphics2D.setRenderingHint(RenderingHints.KEY_INTERPOLATION,

RenderingHints.VALUE_INTERPOLATION_BILINEAR);

graphics2D.drawImage(image, 0, 0, thumbWidth, thumbHeight, null);

// save thumbnail image to OUTFILE

BufferedOutputStream out;
try {

out = new BufferedOutputStream(new

FileOutputStream(outputFile+"_"+i+".jpg"));

JPEGImageEncoder encoder = JPEGCodec.createJPEGEncoder(out);

JPEGEncodeParam param = encoder.

getDefaultJPEGEncodeParam(thumbImage);

int quality = Integer.parseInt(qualityOfImage);

quality = Math.max(0, Math.min(quality, 100));

param.setQuality((float)quality / 100.0f, false);

encoder.setJPEGEncodeParam(param);

encoder.encode(thumbImage);

//Encoding it into a byte stream to store it in the database
File imageFile = new File(outputFile+"_"+i+".jpg");

imageAsBytes = getBytesFromFile(imageFile);

}
catch (FileNotFoundException e)
{
// TODO Auto-generated catch block
e.printStackTrace();

} catch (ImageFormatException e1)
{
// TODO Auto-generated catch block
e1.printStackTrace();

} catch (IOException e2)
{
// TODO Auto-generated catch block
e2.printStackTrace();
}
}//end of for loop
return imageAsBytes;
}

/**
*
* @param im
* @return
*/
public static BufferedImage convert(Image im)
{
int imgHeight=im.getHeight(null);
int imgWidth= im.getWidth(null) ;
BufferedImage bi = new BufferedImage( 1024 , 768 , BufferedImage.TYPE_INT_RGB);
Graphics bg = bi.getGraphics();
bg.drawImage(im, 0, 0, null);
bg.dispose();
return bi;
}
/**
* returns the byte array to the corresponding file
* @param file
* @return byte[]
* @throws IOException
*/
private static byte[] getBytesFromFile(File file) throws IOException
{

InputStream is = new FileInputStream(file);

ByteArrayOutputStream bytestream = new ByteArrayOutputStream();

final int DEFAULT_BUFFER_SIZE = 1024 * 4;

byte[] buffer = new byte[DEFAULT_BUFFER_SIZE];

int count = 0;

int num = 0;

while ((num = is.read(buffer)) != -1)
{
   bytestream.write(buffer, 0, num);

    count += num;
   }
return bytestream.toByteArray();
}

}

CONFIGURING SSL IN JAVA (SECURE SOCKET LAYER)

noreply@blogger.com (Ravinderjeet S. Nagpal) — Tue, 06 Jan 2009 09:01:00 +0000

CONFIGURING SSL IN JAVA (SECURE SOCKET LAYER)

One of the great things about the Java programming language is the Open Source community that provides great applications at little or no cost. An example of this is Apache Tomcat, which provides a solid Web server for development using servlet or JSP technology. Now that Web Service technology is maturing there's a potential for a whole scenario of applications to take advantage of a Swing feature-rich thin client on the front-end coupled to the data verification and business logic already developed in the Web or ejb tier. Such applications are only viable if they can be secure, however, security doesn't have to come at a great cost. The purpose of this article is to demonstrate how Web Service clients can use self-signed security certificates over the secure HTTPS protocol.

The Problem with Using Self-Signed Certificates
HTTPS typically works seamlessly with the non-secure HTTP protocol and doesn't interrupt the user's experience. This is because SSL certificates are designed to be verified and signed by a trusted third party. Verisign is a popular certificate authority. If a Web application requires secure communication, you can pay Verisign to sign your SSL certificate. Once Verisign does that, users on your Web site can switch between HTTP and HTTPS without interruption because all major Web browsers trust certificates signed by Verisign. Verisign is not the only option for getting certificates signed. To save operating costs, or for personal use, you can self-sign your own certificate. However, self-signing your certificate will interrupt your Web site user's experience. Typically the Web browser will display a dialog box asking if you want to trust a certificate you signed.

Web browsers are nice because when they get a certificate signed by an unknown certificate authority there's an option to proceed. When developing Web Service clients for communication over HTTPS it's not so easy. When running Java code there's no dialog box asking about trusting a distrusted certificate authority. The JRE will throw an exception trying to connect over HTTPS to a Web site with a distrusted certificate:

Caused by: sun.security.validator.ValidatorException: No trusted certificate found

There's no way to catch this exception and continue. To get the Web Service to work with a self-signed certificate the JRE has to somehow trust you as a certificate authority.

Solution Outline
To demonstrate a solution to this problem I'll do the following:

Generate and self-sign my own certificate
Configure Tomcat for SSL and make it use that certificate
Create an example Web Service to be called over HTTPS
Generate Web Service client code from WSDL
Demonstrate a client using a custom keystore solution

Generating a Self-Signed Certificate
The JDK comes with a tool, keytool.exe, that is used to mange SSL public/private keys. Keys are added and removed from a binary file on the file system. The default keystore file is JAVA_HOME\jre\lib\security\cacerts. This file contains the list of certificate authorities that the JRE will trust. A list of well-known trusted companies like Verisign is already in the keystore. To see this list, execute with password "changeit":

D:\>keytool -list -rfc -keystore JAVA_HOME\jre\lib\security\cacerts

The keytool application can be used to edit this file. However, just in case something goes wrong it's better to create a new file. If keytool isn't told which file to use it creates HOME/.keystore by default.

To generate your own self-signed certificate execute:

D:\>keytool.exe -genkey -alias Tomcat -keyalg RSA -storepass bigsecret -keypass bigsecret -dname "cn=localhost"

After executing this command there will be a .keystore file in your HOME directory. Here's what the switches mean.

genkey: Tells the keytool applica-tion to generate new public/private key pair.
alias: The name used to refer to the keys. Remember, the .keystore file can contain many keys.
keyalg: Generates public/private keys using the RSA algorithm.
storepass: What password is needed to access the .keystore file.
keypass: What password is needed to manage the keys.
dname: This value is very important. I used "localhost" because this example is designed to run locally. If a Web application is registered as http://www.myserver.com then this value must be www.myserver.com. If the names don't match the certificate will automatically be rejected.

Once the keytool application creates a new public/private key pair it automatically self-signs the key. You have just generated your own self-signed certificate, which can be used for HTTPS communications. You only need to extract the self-signed public key. I'll show how to do this later.

Configuring Tomcat for SSL
Now you have to configure Tomcat to use your self-signed certificate. I used Tomcat 5.0.30. Edit the TOMCAT/conf/server.xml file. Search the file for "8443" and uncomment the <Connector.../> bound to that port. Then you'll have to add the following property to the <Connector.../>:

keystorePass="bigsecret"

When the JRE starts, it will automatically find the HOME/.keystore file and Tomcat will try to access it using the password "bigsecret." When Tomcat starts there should be output to the console that looks similar to:

Feb 4, 2006 3:11:23 PM org.apache.coyote.http11.Http11Protocol start
INFO: Starting Coyote HTTP/1.1 on http-8443

This means the <Connector.../> successfully read the .keystore file and you can now do secure HTTPS connections over the 8443 port. Open a Web browser and try https://localhost:8443/. Because the certificate is self-signed the Web browser will display a dialog box asking about trusting the connection. If accepted, all communications will be secure over HTTPS.

Creating the Web Service
I'm going to use the Apache Axis project to create a very simple Web Service. The Web Service will simulate checking for new e-mail messages. A Web Service client passes a token uniquely identifying a user. The Web Service returns a list of new e-mail messages (see Listing 1).

To get the Web Service deployed, follow these steps:

Cut and paste the code from Listing 1 into a file named Email.jws in Webapp's root directory.
Edit the Web.xml file, adding the Axis servlet and a *.jws mapping (Listing 2).
Put the Axis jar files in WEB-INF/lib. See References at the end of this article for the Axis project URL.

After deploying this article's accompanying WAR file (and configuring Tomcat for SSL), the Web Service is accessible securely over HTTPS at the following URL:

https://localhost:8443/JDJArticleWebService/Email.jws

Using WSDL2Java
The Axis project provides a tool named WSDL2Java that takes a Web Service WSDL and automatically create the Java source code needed to use the Web Service. See Listing 3 for the command line used to generate code for the Email.jws Web Service.

Notice the URL in Listing 3 used to access the WSDL. It's the non-secure HTTP protocol over port 8080. Why not use HTTPS over port 8443? Because of the self-signed certificate, the WSDL2Java tool will encounter the same exact certificate problem this article is trying to provide a solution for. So for now the non-secure protocol must be used. This means the generated code must be altered slightly replacing "http" and "8080" references with "https" and "8443." This article's accompanying client zip file contains the altered code.

Client with a Custom Keystore
The JRE's default keystore is JAVA_HOME\jre\lib\security\cacerts. Java applications will throw an exception whenever they are presented with your self-signed certificate because your certificate isn't in this keystore. Therefore, when developing a client there are two options. The first option is to put your self-signed certificate into the JRE's default keystore. Although this would work it's not a very good solution because customization is required on every client machine. The second option is to generate a custom keystore, put your self-signed certificate into it, and distribute the custom keystore as part of your application (typically inside a jar file).

To create a custom keystore for your client the following has to be done:

Export the self-signed public key from HOME/.keystore.
Import the self-signed public key into a new keystore for you client.

To export the self-signed public key from HOME/.keystore execute the following:

D:\>keytool.exe -export -rfc -alias Tomcat -file Tomcat.cer -storepass bigsecret -keypass bigsecret

Now create the custom keystore for the client by importing Tomcat.cer:

D:>keytool.exe -import -noprompt -trustcacerts -alias Tomcat -file Tomcat.cer -keystore CustomKeystore -storepass littlesecret

Using the switch "-keystore CustomKeystore" will create a new keystore file called "CustomKeystore" in the present working directory. You'll find the CustomKeystore file in the /classpath/resources/keystore directory of this article's client zip file. Replace this one with the file just generated.

Now all that's left to do is to create a client that uses this custom keystore. I'll demonstrate two ways to do this.

The first is to use the Java system properties javax.net.ssl.trustStore and javax.net.ssl.trustStorePassword to point to the CustomKeystore file and provide the password to access it. My example Web Service client in the jdj.wsclient.truststore package takes this approach (see Listing 4). The main() method sets the system properties then creates the objects to use the Web Service. When the JRE needs to access a keystore it looks for the "classpath/resources/keystore/CustomKeystore" file on the file system. Although this is a simple solution it's problematic because the keystore file must be on the file system and the client code must know where to look for it.

The second is a more portable solution that keeps resources inside the jar file and avoids the file system issues. The client code is responsible for reading the CustomKeystore file and somehow using it to create a secure connection to the server. My example Web Service client in the jdj.wsclient.socketfactory package takes this approach (see Listing 5). Listing 5 shows how to read the CustomKeystore file as a resource and use it to create a javax.net.ssl.SSLSocketFactory. Configuring the Axis pluggable architecture, the MySocketFactory class can be then used to create secure Socket objects from this factory.

Conclusion
This article started with a simple problem: I wanted to secure Web Service communications over HTTPS using my own self-signed certificates. By default, the JRE will reject my application's self-signed certificate because I am not a trusted certificate authority. To get secure communications to work I had to get the Web Service client JRE to trust my self-signed certificate. To achieve this, I used the keytool application and generated a new public/private key pair, extracted the self-signed public key, and then created a new keystore and imported this self-signed certificate. I then created a totally self-contained Web Service client that doesn't require any client-side configuration.

"javax.activation.UnsupportedDataTypeException: no object DCH for MIME type xxx/xxxx javax.mail.MessagingException: IOException while sending message;

noreply@blogger.com (Ravinderjeet S. Nagpal) — Tue, 06 Jan 2009 08:59:00 +0000

javax.activation.UnsupportedDataTypeException: no object DCH for MIME type xxx/xxxx javax.mail.MessagingException: IOException while sending message;

I was using a custom Java wrapper class I developed for the background processing of emails from Java apps when I encountered these issues with unhandled MIME types, specifically "text/html" and "multipart/*".

For me, the initial solution was (as suggested in this forum at the outset) providing for these types via the mailcap file (either external or located in the META-INF folder of the distribution jar). However, I subsequently ended up adding the following lines to my email wrapper class:

// add handlers for main MIME types MailcapCommandMap mc = (MailcapCommandMap)CommandMap.getDefaultCommandMap(); mc.addMailcap("text/html;; x-java-content-handler=com.sun.mail.handlers.text_html"); mc.addMailcap("text/xml;; x-java-content-handler=com.sun.mail.handlers.text_xml"); mc.addMailcap("text/plain;; x-java-content-handler=com.sun.mail.handlers.text_plain"); mc.addMailcap("multipart/*;; x-java-content-handler=com.sun.mail.handlers.multipart_mixed"); mc.addMailcap("message/rfc822;; x-java-content-handler=com.sun.mail.handlers.message_rfc822"); CommandMap.setDefaultCommandMap(mc);

This works fine, and keeps all the relevant dependencies in one place, so I know it will always work irrespective of the overall Java app configuration. Another reason was speed, as the following excerpt from the relevant javadoc proves:

(http://java.sun.com/j2ee/1.4/docs/api/javax/activation/MailcapCommandMap.html)

The MailcapCommandMap looks in various places in the user's system for mailcap file entries. When requests are made to search for commands in the MailcapCommandMap, it searches mailcap files in the following order:

1) Programatically added entries to the MailcapCommandMap instance.
2) The file .mailcap in the user's home directory.
3) The file <java.home>/lib/mailcap.
4) The file or resources named META-INF/mailcap.
5) The file or resource named META-INF/mailcap.default (usually found only in the activation.jar file).

Code for creating and writing to a Excel Sheet

noreply@blogger.com (Ravinderjeet S. Nagpal) — Wed, 31 Dec 2008 11:28:00 +0000

JExcel API provides various classes to create, read, write data to Excel documents at runtime. The required platform is JVM which means the code developed with JExcel can be run on Windows and Linux without any modification.

The example below creates a new document and writes data into different sheets of the new Excel document.

import java.io.*;

import jxl.*;

import java.util.*;

import jxl.Workbook;

import jxl.write.DateFormat;

import jxl.write.Number;

import jxl.write.*;

import java.text.SimpleDateFormat;

class create

{

public static void main(String[] args)

{

try

{

String filename = "input.xls";

WorkbookSettings ws = new WorkbookSettings();

ws.setLocale(new Locale("en", "EN"));

WritableWorkbook workbook =

Workbook.createWorkbook(new File(filename), ws);

WritableSheet s = workbook.createSheet("Sheet1", 0);

WritableSheet s1 = workbook.createSheet("Sheet1", 0);

writeDataSheet(s);

writeImageSheet(s1);

workbook.write();

workbook.close();

}

catch (IOException e)

{

e.printStackTrace();

}

catch (WriteException e)

{

e.printStackTrace();

}

private static void writeDataSheet(WritableSheet s)

throws WriteException

{

/* Format the Font */

WritableFont wf = new WritableFont(WritableFont.ARIAL,

10, WritableFont.BOLD);

WritableCellFormat cf = new WritableCellFormat(wf);

cf.setWrap(true);

/* Creates Label and writes date to one cell of sheet*/

Label l = new Label(0,0,"Date",cf);

s.addCell(l);

WritableCellFormat cf1 =

new WritableCellFormat(DateFormats.FORMAT9);

DateTime dt =

new DateTime(0,1,new Date(), cf1, DateTime.GMT);

s.adCell(dt);

/* Creates Label and writes float number to one cell of sheet*/

l = new Label(2,0,"Float", cf);

s.addCell(l);

WritableCellFormat cf2 = new WritableCellFormat(NumberFormats.FLOAT);

Number n = new Number(2,1,3.1415926535,cf2);

s.addCell(n);

n = new Number(2,2,-3.1415926535, cf2);

s.addCell(n);

/* Creates Label and writes float number upto 3

decimal to one cell of sheet */

l = new Label(3,0,"3dps",cf);

s.addCell(l);

NumberFormat dp3 = new NumberFormat("#.###");

WritableCellFormat dp3cell = new WritableCellFormat(dp3);

n = new Number(3,1,3.1415926535,dp3cell);

s.addCell(n);

/* Creates Label and adds 2 cells of sheet*/

l = new Label(4, 0, "Add 2 cells",cf);

s.addCell(l);

n = new Number(4,1,10);

s.addCell(n);

n = new Number(4,2,16);

s.addCell(n);

Formula f = new Formula(4,3, "E1+E2");

s.addCell(f);

/* Creates Label and multipies value of one cell of sheet by 2*/

l = new Label(5,0, "Multipy by 2",cf);

s.addCell(l);

n = new Number(5,1,10);

s.addCell(n);

f = new Formula(5,2, "F1 * 3");

s.addCell(f);

/* Creates Label and divide value of one cell of sheet by 2.5 */

l = new Label(6,0, "Divide",cf);

s.addCell(l);

n = new Number(6,1, 12);

s.addCell(n);

f = new Formula(6,2, "F1/2.5");

s.addCell(f);

}

private static void writeImageSheet(WritableSheet s)

throws WriteException

{

/* Creates Label and writes image to one cell of sheet*/

Label l = new Label(0, 0, "Image");

s.addCell(l);

WritableImage wi = new WritableImage(0, 3, 5, 7, new File("image.png"));

s.addImage(wi);

/* Creates Label and writes hyperlink to one cell of sheet*/

l = new Label(0,15, "HYPERLINK");

s.addCell(l);

Formula f = new Formula(1, 15,

"HYPERLINK(\"http://www.andykhan.com/jexcelapi\", "+

"\"JExcelApi Home Page\")");

s.addCell(f);

}